# sign problem

Status
Not open for further replies.

DanMun

New Member
Joined
Feb 18, 2011
Messages
43
Trying to put a number in a cell and I'm getting the # sign. I've tried enlarging the cell and have tried changing the cell formatting from general to number. Nothing is working! Would appreciate help please!
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,782
Office Version
  1. 2010
Platform
  1. Windows
Is this a different question than your prior thread?
 

DanMun

New Member
Joined
Feb 18, 2011
Messages
43
Same question but received no help! Would appreciate ANY help!

Thanks-
Dan
 

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
Same question but received no help! Would appreciate ANY help!

Thanks-
Dan

"Not getting resolution" does not equal "not getting help"....

Seems someone asked for additional information to your problem which was not provided.
 

DanMun

New Member
Joined
Feb 18, 2011
Messages
43
Thought that I provided all info but apparently I left something out. Would be glad to provide all information to anyone for help. Problem is: I'm trying to put a two digit number in a cell and when I do I get the # sign. I've tried enlarging the cell, changing font, and changing formatting from general to number. I hope this provides the info required to assist me with this problem.

Thanks-
Dan
 

Jon von der Heyden

MrExcel MVP, Moderator
Joined
Apr 6, 2004
Messages
10,808
Office Version
  1. 365
Platform
  1. Windows
Per the forum rules threads of a duplicate nature will be deleted or locked. All follow-ups, be they clarifications, further questions or bumps should be posted back to the original thread.
 
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,123,321
Messages
5,600,950
Members
414,417
Latest member
Nobu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top