Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook cells won't hold formatting in Office 2007
I have Office 2007 running in Vista Home Premium. My system got FUBARed and
had to be reloaded. Now my Excel workbooks won't keep the proper formatting in cells. I have them formatted as general so that I can type in something like 4 - 1. As soon as I do that it converts the formatting to Custom and puts it in as a 1-Apr. If I try to reformat the cell as general I then get 39904. If I enter it as space 4 - 1 then it enters correctly. How can I make the cell give me the correct information without putting a space in front of it? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook cells won't hold formatting in Office 2007
One way in to format the cell as Text BEFORE entering 4-1. Another way is
to precede the 4-1 with an apostrophe. HTH Otto "Deej Hernandez" wrote in message ... I have Office 2007 running in Vista Home Premium. My system got FUBARed and had to be reloaded. Now my Excel workbooks won't keep the proper formatting in cells. I have them formatted as general so that I can type in something like 4 - 1. As soon as I do that it converts the formatting to Custom and puts it in as a 1-Apr. If I try to reformat the cell as general I then get 39904. If I enter it as space 4 - 1 then it enters correctly. How can I make the cell give me the correct information without putting a space in front of it? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook cells won't hold formatting in Office 2007
Rather than formatting them as 'General', try formatting them as 'Text'.
That should prevent Excel from converting 4-1 to 1 Apr. Or, if you prefer, leave them formatted as General, but instead of putting a space in front of the entry, put a single quote mark ( ' ) in front of it, as: '4-1 which will force Excel to treat the entry as text regardless of the cell's format setting. "Deej Hernandez" wrote: I have Office 2007 running in Vista Home Premium. My system got FUBARed and had to be reloaded. Now my Excel workbooks won't keep the proper formatting in cells. I have them formatted as general so that I can type in something like 4 - 1. As soon as I do that it converts the formatting to Custom and puts it in as a 1-Apr. If I try to reformat the cell as general I then get 39904. If I enter it as space 4 - 1 then it enters correctly. How can I make the cell give me the correct information without putting a space in front of it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Help in Office 2007 | Excel Discussion (Misc queries) | |||
Office 2007 Conditional Formatting | Excel Discussion (Misc queries) | |||
Max with Conditional Formatting in Office 2007 | Excel Worksheet Functions | |||
unsharing excel workbook in office 2007 | Excel Discussion (Misc queries) | |||
Office 2007 - protecting workbook | Excel Discussion (Misc queries) |