Home |
Search |
Today's Posts |
#1
|
|||
|
|||
data in some cells of worksheet appear as #### why?
When I saved the data originally it was fine then when i came back to work on
it in the morning it appeared as a row of ##### can anyone tell why & how I can get my data to appear corectly? |
#2
|
|||
|
|||
Because the column is not wide enough. Widen it.
-- HTH Bob Phillips "jlacmana" wrote in message ... When I saved the data originally it was fine then when i came back to work on it in the morning it appeared as a row of ##### can anyone tell why & how I can get my data to appear corectly? |
#3
|
|||
|
|||
Are you running xl97?
Some posters say that upgrading to SR2 helps. But others have said that it had no effect. If you're not running xl97SR2, you may want to try it. jlacmana wrote: When I saved the data originally it was fine then when i came back to work on it in the morning it appeared as a row of ##### can anyone tell why & how I can get my data to appear corectly? -- Dave Peterson |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
data in some cells of worksheet appear as #### why?
Woah.. It really was that simple!! I was tearing my hair out over it!
The Excel help in the program is really useless. Thanks so much Bob! -m.m.m. "Bob Phillips" wrote: Because the column is not wide enough. Widen it. -- HTH Bob Phillips "jlacmana" wrote in message ... When I saved the data originally it was fine then when i came back to work on it in the morning it appeared as a row of ##### can anyone tell why & how I can get my data to appear corectly? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
data in some cells of worksheet appear as #### why?
If you look under help for "error" you will find "how to correct ##### error"
So not really that useless, is it? Gord Dibben MS Excel MVP On Mon, 14 Jul 2008 09:28:01 -0700, m.m.m. wrote: Woah.. It really was that simple!! I was tearing my hair out over it! The Excel help in the program is really useless. Thanks so much Bob! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference multiple cells in if statement | Excel Worksheet Functions | |||
Removing blank rows in a worksheet | Excel Worksheet Functions | |||
Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) | |||
REPOST: How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |