Ask Question Forum:
Model Library:2025-02-08:A.I. model is online auto reply
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by StevenHook
at 2024-07-25 00:12:14
ModifyPoint:500 Replies:8 POST_ID:829096USER_ID:11995
Topic:
Microsoft Excel Spreadsheet Software;Microsoft Office Suite;Office Suites
Hi,
I have a spreadsheet with names and dates to be printed onto certificates.
The dates are formatted in excel to look like "9 July 2014" but when you double-click the cell it reads 9/7/14 in the formula bar. and in the print software it's picking up as "9/7/14"
Is there not a way to copy the formatted date text from that column and paste it as text instead of as a date?
Thanks
Steve
I have a spreadsheet with names and dates to be printed onto certificates.
The dates are formatted in excel to look like "9 July 2014" but when you double-click the cell it reads 9/7/14 in the formula bar. and in the print software it's picking up as "9/7/14"
Is there not a way to copy the formatted date text from that column and paste it as text instead of as a date?
Thanks
Steve
Author: StevenHook replied at 2024-07-25 01:59:39
That looks like it's working - thanks!
Accepted Solution
Expert: duncanb7 replied at 2024-07-25 01:02:18
300 points EXCELLENT
you can convert it to text from A1="9 Jan 2014" to B1 with this formula
=TEXT(B1,"dd mmmm yyyy"),
Is it what you need?
Duncan
=TEXT(B1,"dd mmmm yyyy"),
Is it what you need?
Duncan
Assisted Solution
Expert: Rob Henson replied at 2024-07-25 00:58:29
200 points EXCELLENT
If you are not using the date for any calculations convert it to text using the following formula, assuming date in column B:
=TEXT(B2,"dd mmmm yy")
Then copy and paste values to overwrite if so required.
Thanks
Rob H
=TEXT(B2,"dd mmmm yy")
Then copy and paste values to overwrite if so required.
Thanks
Rob H
Expert: duncanb7 replied at 2024-07-25 00:51:58
Now I know it, it is normal, why you double-click the cell? for what ?
Author: StevenHook replied at 2024-07-25 00:35:40
I'm sorry, you're not understanding the problem.
The dates are formatted in excel to look like "9 July 2014" (which is what we want) but when you double-click the cell it reads 9/7/14 in the formula bar. and in the print software it's picking up as "9/7/14"
The dates are formatted in excel to look like "9 July 2014" (which is what we want) but when you double-click the cell it reads 9/7/14 in the formula bar. and in the print software it's picking up as "9/7/14"
Expert: duncanb7 replied at 2024-07-25 00:28:28
Since the cell you paste is formated to number
so you should do it not just copy cells bus paste cells also
Duncan
so you should do it not just copy cells bus paste cells also
Duncan
Author: StevenHook replied at 2024-07-25 00:24:45
Hi,
Yes, we have formatted it correctly like that. so it looks right on the sheet.
But when you copy it, or it copies 9/7/14 or when you format as text it gives some number other strange number (like maybe 5 or 6 digits)
Thanks
Steven
Yes, we have formatted it correctly like that. so it looks right on the sheet.
But when you copy it, or it copies 9/7/14 or when you format as text it gives some number other strange number (like maybe 5 or 6 digits)
Thanks
Steven
Expert: duncanb7 replied at 2024-07-25 00:18:13
You can select the cells you want, and mouse right-click->format cells
There is a lot of options for date such as "11 Jun 2014"
Take a look at Excel on Mac for format cell insruction
http://www.dummies.com/how-to/content/office-2011-for-mac-format-dates-and-times-in-exce.html
Duncan
There is a lot of options for date such as "11 Jun 2014"
Take a look at Excel on Mac for format cell insruction
http://www.dummies.com/how-to/content/office-2011-for-mac-format-dates-and-times-in-exce.html
Duncan
