I have a fairly developed forecasting model in Excel. Somehow the default format got changed to date format. Anytime I insert a new tab, pull new columns into a pivot table it defaults to a date format. Any idea how change the default to a numeric setting instead of date format? Thanks.
This might be helpful.
http://www.vitalyst.com/2011/03/prod...lt-formatting/
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Hey Hawk and welcome to the forum,
When you want text instead of numbers, type a single quote followed by your numbers. This will then treat those numbers as text.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks